Automatic Generation of Secure Multidimensional Code for Data Warehouses by using QVT Transformations: an MDA Approach

Data Warehouses manage vital information for the decision making process, which may be discovered by unauthorized users if we do not establish security measures in all the stages of the development process. We have proposed an MDA architecture to develop secure Data Warehouses which allows them to be modeled at different abstraction levels (business, conceptual, logical and code level). We take into consideration security constraints in all models and we automatically transform models through QVT rules. This paper presents a set of QVT transformations focused on obtaining structural aspects (of cubes, dimensions or hierarchies) and security measures defined at a conceptual level in the final secure code for a specific OLAP tool.